

USE [RD_COMMON]
GO
truncate table AR_Star_Customer
go
truncate table Sales_Star_Customer
go


/****** Object:  Index [IX_Sales_Star_CompanyNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_CompanyNumber')
DROP INDEX [IX_Sales_Star_CompanyNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_Customer_CustomerNumberID]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_Customer_CustomerNumberID')
DROP INDEX [IX_Sales_Star_Customer_CustomerNumberID] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_Customer_ShipToNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_Customer_ShipToNumber')
DROP INDEX [IX_Sales_Star_Customer_ShipToNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_InvoiceToNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_InvoiceToNumber')
DROP INDEX [IX_Sales_Star_InvoiceToNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_ParentNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_ParentNumber')
DROP INDEX [IX_Sales_Star_ParentNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_ShipToNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_ShipToNumber')
DROP INDEX [IX_Sales_Star_ShipToNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_SoldToNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_SoldToNumber')
DROP INDEX [IX_Sales_Star_SoldToNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_1]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_1')
DROP INDEX [missing_index_1] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_101]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_101')
DROP INDEX [missing_index_101] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_103]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_103')
DROP INDEX [missing_index_103] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_105]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_105')
DROP INDEX [missing_index_105] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_107]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_107')
DROP INDEX [missing_index_107] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_109]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_109')
DROP INDEX [missing_index_109] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_111]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_111')
DROP INDEX [missing_index_111] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_115]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_115')
DROP INDEX [missing_index_115] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_117]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_117')
DROP INDEX [missing_index_117] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_121]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_121')
DROP INDEX [missing_index_121] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_123]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_123')
DROP INDEX [missing_index_123] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_125]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_125')
DROP INDEX [missing_index_125] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_128]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_128')
DROP INDEX [missing_index_128] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_144]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_144')
DROP INDEX [missing_index_144] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_1465]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_1465')
DROP INDEX [missing_index_1465] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_147]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_147')
DROP INDEX [missing_index_147] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_1473]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_1473')
DROP INDEX [missing_index_1473] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_152]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_152')
DROP INDEX [missing_index_152] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_157]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_157')
DROP INDEX [missing_index_157] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_159]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_159')
DROP INDEX [missing_index_159] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_170]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_170')
DROP INDEX [missing_index_170] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_177]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_177')
DROP INDEX [missing_index_177] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_179]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_179')
DROP INDEX [missing_index_179] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_180]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_180')
DROP INDEX [missing_index_180] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_19]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_19')
DROP INDEX [missing_index_19] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_202]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_202')
DROP INDEX [missing_index_202] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_204]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_204')
DROP INDEX [missing_index_204] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_206]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_206')
DROP INDEX [missing_index_206] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_208]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_208')
DROP INDEX [missing_index_208] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_212]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_212')
DROP INDEX [missing_index_212] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_214]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_214')
DROP INDEX [missing_index_214] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_216]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_216')
DROP INDEX [missing_index_216] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_225]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_225')
DROP INDEX [missing_index_225] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_242]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_242')
DROP INDEX [missing_index_242] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_272]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_272')
DROP INDEX [missing_index_272] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_276]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_276')
DROP INDEX [missing_index_276] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_32]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_32')
DROP INDEX [missing_index_32] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_357]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_357')
DROP INDEX [missing_index_357] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_493]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_493')
DROP INDEX [missing_index_493] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_517]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_517')
DROP INDEX [missing_index_517] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_519]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_519')
DROP INDEX [missing_index_519] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_534]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_534')
DROP INDEX [missing_index_534] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_6]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_6')
DROP INDEX [missing_index_6] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_648]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_648')
DROP INDEX [missing_index_648] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_652]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_652')
DROP INDEX [missing_index_652] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_653]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_653')
DROP INDEX [missing_index_653] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_7]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_7')
DROP INDEX [missing_index_7] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_8]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_8')
DROP INDEX [missing_index_8] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_83]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_83')
DROP INDEX [missing_index_83] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_87]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_87')
DROP INDEX [missing_index_87] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_908]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_908')
DROP INDEX [missing_index_908] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_YCHOI1]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'missing_index_YCHOI1')
DROP INDEX [missing_index_YCHOI1] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [PK_Sales_Star_Customer]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'PK_Sales_Star_Customer')
ALTER TABLE [dbo].[Sales_Star_Customer] DROP CONSTRAINT [PK_Sales_Star_Customer]
GO


USE [RD_COMMON]
GO

/****** Object:  Index [IX_AR_Star_BillToNumber]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_BillToNumber')
DROP INDEX [IX_AR_Star_BillToNumber] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_AR_Star_Customer_BillTo_Company]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_Customer_BillTo_Company')
DROP INDEX [IX_AR_Star_Customer_BillTo_Company] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_AR_Star_Customer_CustomerNumberID]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_Customer_CustomerNumberID')
DROP INDEX [IX_AR_Star_Customer_CustomerNumberID] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_AR_Star_CustomerNumber]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_CustomerNumber')
DROP INDEX [IX_AR_Star_CustomerNumber] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_AR_Star_ParentNumber]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_ParentNumber')
DROP INDEX [IX_AR_Star_ParentNumber] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [missing_index_487]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'missing_index_487')
DROP INDEX [missing_index_487] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [PK_AR_Star_Customer]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'PK_AR_Star_Customer')
DROP INDEX [PK_AR_Star_Customer] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

